﻿---------------------------------------------------------------------------------------------------
--	PaymentTypes Population Script
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

IF EXISTS(SELECT 1 FROM dbo.TypesOfPayment)
BEGIN
	PRINT 'TypesOfPayment already populated; no action taken'
END
ELSE
BEGIN
	SET IDENTITY_INSERT dbo.TypesOfPayment ON
	
	INSERT INTO dbo.TypesOfPayment ( OID, Description, Active, DisplayOrder, CreatedDate ) 
		VALUES( 1, 'Card', 1, 10, GetDate() ) 
	
	INSERT INTO dbo.TypesOfPayment ( OID, Description, Active, DisplayOrder, CreatedDate ) 
		VALUES( 2, 'Check', 1, 20, GetDate() ) 
	
	INSERT INTO dbo.TypesOfPayment ( OID, Description, Active, DisplayOrder, CreatedDate ) 
		VALUES( 3, 'Materials', 1, 30, GetDate() ) 
	
	SET IDENTITY_INSERT dbo.TypesOfPayment OFF
	
	PRINT 'TypesOfPayment has been populated'
END